<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Displaying and hiding grand totals and subtotals</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
p.whs2 { margin-left:0px; }
img_whs3 { border:none; width:20px; height:19px; float:none; border-style:none; }
p.whs4 { margin-left:40px; }
ul.whs5 { list-style:square; }
img_whs6 { border:none; width:22px; height:22px; float:none; border-style:none; }
ul.whs7 { list-style:disc; }
p.whs8 { font-weight:bold; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs2 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nDisplaying and modifying grand totals and subtotals\nDisplaying and hiding grand totals and subtotals");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Displaying and hiding grand totals and subtotals</h1>
<p>A grand total is a total of all calculations on a report, per metric. 
 A subtotal is a total of a specific subset of metric data, totaled at 
 a level you select. (For a definition and examples of levels of aggregation, 
 see the <span style="font-style: italic;"><I>MicroStrategy Basic Reporting 
 Guide</I></span>.) Common subtotal functions include sum, count, minimum, 
 maximum, average, mean, and median. Grand totals and subtotals are often 
 collectively referred to as totals.</p>
<p>A metric designer or report designer must enable totals as part of a 
 metric's definition. If totals are available for a metric, you can display 
 or hide them for that metric on a given report. You can add a new type 
 of subtotal to the report. For example, if a report currently displays 
 a Median subtotal, but you would prefer to see an Average subtotal, you 
 can add the Average subtotal to the report. You can also permanently remove 
 totals from the report.</p>
<h2>To display or hide existing grand totals and subtotals on a report</h2>
<ol type="1" class="whs1">
	
<li class=p><p class="whs2">Click the name of a report 
 to execute it. The report must be in either Grid view or Grid and Graph 
 view.</p></li>
	
<li class=p><p>Click <span style="font-weight: bold;"><B>Toggle Totals</B></span> 
 <img src="images/Toggle_totals.gif" x-maintain-ratio="TRUE" width="20px" height="19px" border="0" class="img_whs3"> 
 on the Data toolbar. Subtotals are displayed at all levels of the report.</p></li>
</ol>
<p class="whs4">Alternatively, from the <span style="font-weight: bold;"><B>Data</B></span> 
 menu, select <span style="font-weight: bold;"><B>Show Totals</B></span>. If this 
 option does not appear, this means totals have not been enabled for at 
 least one metric on the report; see Prerequisites, above.</p>
<ol><ul type="square" class="whs5">
		
<li class=p><p>If DHTML is disabled, click the <span style="font-weight: bold;"><B>Go</B></span> 
 icon.</p></li>
	</ul>
</ol>
<h2>To display new totals on a report</h2>
<ol start="1" type="1" class="whs1">
	
<li class=p><p class="whs2">Click the name of a report 
 to execute it. The report must be in either Grid view or Grid and Graph 
 view.</p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Data</B></span> 
 menu, select <span style="font-weight: bold;"><B>Edit Totals </B></span><img src="images/edit_totals.gif" x-maintain-ratio="TRUE" width="22px" height="22px" border="0" class="img_whs6">. 
 The Subtotals dialog box is displayed.</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>If DHTML is 
 disabled, click the <span style="font-weight: bold;"><B>Go</B></span> icon.</p></li>
	</ul>
	
<li class=p><p>Click the <span style="font-weight: bold;"><B>Definitions</B></span> 
 tab. You can add one or more subtotals to be calculated at all levels, 
 or you can add grand totals only.</p></li>
</ol>
<p class="whs4"><span style="font-weight: bold;"><B>Note</B></span>: 
 The list of subtotal functions is determined when the metric is created. 
 If no functions are listed, subtotals have been disabled. For more information, 
 contact the report's creator.</p>
<ol start="4" type="1" class="whs1">
	
<li class=p><p>Click the <span style="font-weight: bold;"><B>Advanced 
 </B></span><span>tab and then, f</span>rom the drop-down list at the top of 
 the dialog box, specify the subtotal for which to specify the way this 
 subtotal should be calculated in the report: by position or across level. 
 </p></li>
</ol>
<p class="whs4"><span style="font-weight: bold;"><B>Note</B></span>: 
 For a definition of a level and examples, see the <span style="font-style: italic;"><I>MicroStrategy 
 Basic Reporting Guide</I></span>.</p>
<p class="whs4">The levels you can select from are:</p>
<ul><ul>
<li style="list-style: disc;" type=disc class=p><p><span style="font-weight: bold;"><B>By 
 position</B></span>: Under the <span style="font-weight: bold;"><B>Rows</B></span>, 
 <span style="font-weight: bold;"><B>Columns</B></span>, or <span style="font-weight: bold;"><B>Pages</B></span> 
 (page-by fields) drop-down lists, select the subtotal to apply to that 
 part of the report. Each of these is considered an axis of the grid report. 
 For each drop-down list, select one of the following:</p></li>
		<ul type="square" class="whs5">
			
<li class=p><p><span style="font-weight: bold;"><B>All Subtotals</B></span>: 
 Apply the subtotal across all levels on the axis.</p></li>
			
<li class=p><p><span style="font-weight: bold;"><B>Grand Total</B></span>: 
 Apply only the subtotal across the whole axis.</p></li>
			
<li class=p><p><span style="font-weight: bold;"><B>None</B></span>: 
 Apply the subtotal to no level of the axis.</p></li>
			
<li class=p><p><span style="font-weight: bold;"><B>Selected Subtotals</B></span>: 
 Apply only selected subtotals across the axis. This option is available 
 only in the Pages drop-down lists, for page-by fields. </p></li>
		</ul>
		
<li style="list-style: disc;" type=disc class=p><p><span style="font-weight: bold;"><B>Across 
 level</B></span>: When you select this, all attributes available in the report 
 are listed for you to choose from. Select those which you want to calculate 
 the subtotal for.</p></li>
	</ul>
</ul>
<ol start="5" type="1" class="whs1">
	
<li class=p><p>Once you have defined which subtotals should be calculated 
 in the report, select the <span style="font-weight: bold;"><B>Display</B></span> 
 tab to define where these subtotals will be displayed in the grid.</p></li>
	
<li class=p><p>For each axis in the grid, any subtotals calculated 
 can be displayed in two ways: top of each level or bottom of each level. 
 </p></li>
	<ul type="disc" class="whs7">
		
<li class=p><p><span style="font-weight: bold;"><B>Subtotal positions 
 by row</B></span>: </p></li>
		<ul type="square" class="whs5">
			
<li class=p><p><span style="font-weight: bold;"><B>Top of each 
 level</B></span>: Displays the row subtotal at the top of each level at which 
 the metric is calculated.</p></li>
			
<li class=p><p><span style="font-weight: bold;"><B>Bottom of each 
 level</B></span>: Displays the row subtotal at the bottom of each level at 
 which the metric is calculated.</p></li>
		</ul>
		
<li class=p><p class="whs8">Subtotal positions by 
 column<span style="font-weight: normal;">:</span></p></li>
		<ul type="square" class="whs5">
			
<li class=p><p class="whs8">Left of each level<span 
 style="font-weight: normal;">: Displays the column subtotal at the left 
 of each level at which the metric is calculated.</span></p></li>
			
<li class=p><p class="whs8">Right of each level<span 
 style="font-weight: normal;">: Displays the column subtotal at the right 
 of each level at which the metric is calculated.</span></p></li>
		</ul>
		
<li class=p><p><span style="font-weight: bold;"><B>Subtotal positions 
 by page</B></span>:</p></li>
		<ul type="square" class="whs5">
			
<li class=p><p><span style="font-weight: bold;"><B>Top of each 
 level</B></span>: Displays the page subtotal at the top of each level at which 
 the metric is calculated.</p></li>
			
<li class=p><p><span style="font-weight: bold;"><B>Bottom of each 
 level</B></span>: Displays the page subtotal at the bottom of each level at 
 which the metric is calculated.</p></li>
		</ul>
	</ul>
	
<li class=p><p>Click <span style="font-weight: bold;"><B>OK</B></span> to 
 complete the subtotal definition. The subtotals are displayed on the report.</p></li>
</ol>
<p>&nbsp;</p>
<h3>Related topics</h3>
<ul type="disc" class="whs7">
	
<li class=p><p>
<a HREF="Removing_totals.htm">Removing totals</a></p></li>
	
<li class=p><p>
<a HREF="Subtotals_dialog_box.htm">Subtotals dialog 
 box</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
